﻿
CREATE PROCEDURE [svc].[GetTopWaitCount]
(
	@FromDate				datetime,
	@ToDate					datetime
)
AS
BEGIN


SELECT TOP 1 WaitTime FROM dbo.ExecSessionLog 
WHERE LastModifiedDate BETWEEN @FromDate AND @ToDate 
ORDER BY WaitTime DESC

END